Profiling Report

Dataset statistics

Number of variables	34
Number of observations	38478
Missing cells	60589
Missing cells (%)	4.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	10.0 MiB
Average record size in memory	272.0 B

Variable types

Numeric	19
Categorical	8
Text	7

Alerts

`loan_amnt` is highly overall correlated with `funded_amnt` and 6 other fields	High correlation
`funded_amnt` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`funded_amnt_inv` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`installment` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`delinq_2yrs` is highly overall correlated with `mths_since_last_delinq`	High correlation
`mths_since_last_delinq` is highly overall correlated with `delinq_2yrs`	High correlation
`open_acc` is highly overall correlated with `total_acc`	High correlation
`total_acc` is highly overall correlated with `open_acc`	High correlation
`total_pymnt` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`total_pymnt_inv` is highly overall correlated with `loan_amnt` and 6 other fields	High correlation
`total_rec_prncp` is highly overall correlated with `loan_amnt` and 7 other fields	High correlation
`total_rec_int` is highly overall correlated with `loan_amnt` and 7 other fields	High correlation
`last_pymnt_amnt` is highly overall correlated with `total_rec_prncp`	High correlation
`term` is highly overall correlated with `total_rec_int`	High correlation
`loan_status` is highly overall correlated with `repay_fail`	High correlation
`repay_fail` is highly overall correlated with `loan_status`	High correlation
`loan_status` is highly imbalanced (64.9%)	Imbalance
`emp_length` has 993 (2.6%) missing values	Missing
`mths_since_last_delinq` has 24362 (63.3%) missing values	Missing
`next_pymnt_d` has 35097 (91.2%) missing values	Missing
`annual_inc` is highly skewed (γ1 = 30.55623967)	Skewed
`delinq_2yrs` has 34200 (88.9%) zeros	Zeros
`inq_last_6mths` has 17787 (46.2%) zeros	Zeros
`mths_since_last_delinq` has 745 (1.9%) zeros	Zeros
`pub_rec` has 36339 (94.4%) zeros	Zeros
`revol_bal` has 976 (2.5%) zeros	Zeros

Reproduction

Analysis started	2023-08-27 15:41:59.812498
Analysis finished	2023-08-27 15:43:36.516996
Duration	1 minute and 36.7 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

loan_amnt
Real number (ℝ)

HIGH CORRELATION

Distinct	880
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11095.016

Minimum	500
Maximum	35000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	500
5-th percentile	2400
Q1	5200
median	9750
Q3	15000
95-th percentile	25000
Maximum	35000
Range	34500
Interquartile range (IQR)	9800

Descriptive statistics

Standard deviation	7405.2963
Coefficient of variation (CV)	0.6674435
Kurtosis	0.78703609
Mean	11095.016
Median Absolute Deviation (MAD)	4750
Skewness	1.0641972
Sum	4.2691402 × 10⁸
Variance	54838413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2727	7.1%
12000	2235	5.8%
5000	2027	5.3%
6000	1842	4.8%
15000	1823	4.7%
20000	1575	4.1%
8000	1550	4.0%
25000	1348	3.5%
4000	1111	2.9%
3000	1013	2.6%
Other values (870)	21227	55.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	10	< 0.1%
550	1	< 0.1%
600	5	< 0.1%
700	3	< 0.1%
725	1	< 0.1%
750	1	< 0.1%
800	2	< 0.1%
850	1	< 0.1%
900	4	< 0.1%
925	1	< 0.1%

Value	Count	Frequency (%)
35000	618	1.6%
34800	2	< 0.1%
34675	1	< 0.1%
34525	1	< 0.1%
34475	5	< 0.1%
34000	15	< 0.1%
33950	8	< 0.1%
33600	5	< 0.1%
33500	2	< 0.1%
33425	2	< 0.1%

funded_amnt
Real number (ℝ)

HIGH CORRELATION

Distinct	1035
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10832.138

Minimum	500
Maximum	35000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	500
5-th percentile	2296.25
Q1	5100
median	9600
Q3	15000
95-th percentile	25000
Maximum	35000
Range	34500
Interquartile range (IQR)	9900

Descriptive statistics

Standard deviation	7146.7332
Coefficient of variation (CV)	0.65977126
Kurtosis	0.94291679
Mean	10832.138
Median Absolute Deviation (MAD)	4600
Skewness	1.0838181
Sum	4.16799 × 10⁸
Variance	51075796
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2642	6.9%
12000	2156	5.6%
5000	2015	5.2%
6000	1829	4.8%
15000	1717	4.5%
8000	1542	4.0%
20000	1417	3.7%
4000	1111	2.9%
25000	1103	2.9%
3000	1004	2.6%
Other values (1025)	21942	57.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
500	10	< 0.1%
550	1	< 0.1%
600	5	< 0.1%
700	3	< 0.1%
725	1	< 0.1%
750	1	< 0.1%
800	2	< 0.1%
850	1	< 0.1%
900	4	< 0.1%
925	1	< 0.1%

Value	Count	Frequency (%)
35000	505	1.3%
34800	1	< 0.1%
34675	2	< 0.1%
34525	1	< 0.1%
34475	4	< 0.1%
34250	1	< 0.1%
34000	14	< 0.1%
33950	5	< 0.1%
33600	5	< 0.1%
33500	1	< 0.1%

funded_amnt_inv
Real number (ℝ)

HIGH CORRELATION

Distinct	8473
Distinct (%)	22.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10150.405

Minimum	0
Maximum	35000
Zeros	200
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1500
Q1	4950
median	8497.6108
Q3	14000
95-th percentile	24561.801
Maximum	35000
Range	35000
Interquartile range (IQR)	9050

Descriptive statistics

Standard deviation	7127.9316
Coefficient of variation (CV)	0.70223123
Kurtosis	1.0670681
Mean	10150.405
Median Absolute Deviation (MAD)	4197.6108
Skewness	1.1047838
Sum	3.905673 × 10⁸
Variance	50807409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	1232	3.2%
10000	1174	3.1%
6000	1116	2.9%
12000	980	2.5%
8000	848	2.2%
3000	762	2.0%
4000	761	2.0%
15000	593	1.5%
7000	566	1.5%
2000	443	1.2%
Other values (8463)	30003	78.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	200	0.5%
0.000121098	1	< 0.1%
0.000185369	1	< 0.1%
0.000242056	1	< 0.1%
0.000531133	1	< 0.1%
0.000571783	1	< 0.1%
0.000654607	1	< 0.1%
0.000899697	1	< 0.1%
0.00092203	1	< 0.1%
0.00108361	1	< 0.1%

Value	Count	Frequency (%)
35000	123	0.3%
34997.35245	1	< 0.1%
34993.65539	1	< 0.1%
34993.26306	1	< 0.1%
34993.19696	1	< 0.1%
34990.4308	1	< 0.1%
34987.98452	1	< 0.1%
34987.27101	1	< 0.1%
34977.34674	1	< 0.1%
34975.81636	1	< 0.1%

term
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

36 months	28592
60 months	9886

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	346302
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	36 months
2nd row	36 months
3rd row	36 months
4th row	36 months
5th row	36 months

Common Values

Value	Count	Frequency (%)
36 months	28592	74.3%
60 months	9886	25.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
months	38478	50.0%
36	28592	37.2%
60	9886	12.8%

Most occurring characters

Value	Count	Frequency (%)
6	38478	11.1%
	38478	11.1%
m	38478	11.1%
o	38478	11.1%
n	38478	11.1%
t	38478	11.1%
h	38478	11.1%
s	38478	11.1%
3	28592	8.3%
0	9886	2.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	230868	66.7%
Decimal Number	76956	22.2%
Space Separator	38478	11.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
m	38478	16.7%
o	38478	16.7%
n	38478	16.7%
t	38478	16.7%
h	38478	16.7%
s	38478	16.7%

Decimal Number

Value	Count	Frequency (%)
6	38478	50.0%
3	28592	37.2%
0	9886	12.8%

Space Separator

Value	Count	Frequency (%)
	38478	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	230868	66.7%
Common	115434	33.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
m	38478	16.7%
o	38478	16.7%
n	38478	16.7%
t	38478	16.7%
h	38478	16.7%
s	38478	16.7%

Common

Value	Count	Frequency (%)
6	38478	33.3%
	38478	33.3%
3	28592	24.8%
0	9886	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	346302	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
6	38478	11.1%
	38478	11.1%
m	38478	11.1%
o	38478	11.1%
n	38478	11.1%
t	38478	11.1%
h	38478	11.1%
s	38478	11.1%
3	28592	8.3%
0	9886	2.9%

int_rate
Real number (ℝ)

Distinct	390
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.162307

Minimum	5.42
Maximum	24.11
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	5.42
5-th percentile	6.39
Q1	9.62
median	11.99
Q3	14.72
95-th percentile	18.61
Maximum	24.11
Range	18.69
Interquartile range (IQR)	5.1

Descriptive statistics

Standard deviation	3.7094849
Coefficient of variation (CV)	0.30499845
Kurtosis	-0.47598526
Mean	12.162307
Median Absolute Deviation (MAD)	2.66
Skewness	0.23462005
Sum	467981.26
Variance	13.760278
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.99	861	2.2%
11.49	759	2.0%
13.49	752	2.0%
7.51	704	1.8%
7.88	675	1.8%
7.49	593	1.5%
11.71	545	1.4%
7.9	529	1.4%
9.99	528	1.4%
5.42	525	1.4%
Other values (380)	32007	83.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5.42	525	1.4%
5.79	390	1.0%
5.99	311	0.8%
6	19	< 0.1%
6.03	412	1.1%
6.17	225	0.6%
6.39	52	0.1%
6.54	278	0.7%
6.62	369	1.0%
6.76	150	0.4%

Value	Count	Frequency (%)
24.11	3	< 0.1%
23.91	11	< 0.1%
23.59	4	< 0.1%
23.52	8	< 0.1%
23.22	9	< 0.1%
23.13	9	< 0.1%
22.94	2	< 0.1%
22.85	7	< 0.1%
22.74	19	< 0.1%
22.64	1	< 0.1%

installment
Real number (ℝ)

HIGH CORRELATION

Distinct	15474
Distinct (%)	40.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	323.17165

Minimum	15.67
Maximum	1305.19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	15.67
5-th percentile	69.7425
Q1	165.74
median	277.98
Q3	429.35
95-th percentile	761.944
Maximum	1305.19
Range	1289.52
Interquartile range (IQR)	263.61

Descriptive statistics

Standard deviation	209.08532
Coefficient of variation (CV)	0.64697915
Kurtosis	1.2029335
Mean	323.17165
Median Absolute Deviation (MAD)	122.42
Skewness	1.1233356
Sum	12434999
Variance	43716.672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
311.11	65	0.2%
180.96	55	0.1%
311.02	47	0.1%
368.45	43	0.1%
150.8	42	0.1%
372.12	42	0.1%
373.33	39	0.1%
186.61	39	0.1%
317.72	39	0.1%
304.36	38	0.1%
Other values (15464)	38029	98.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15.67	1	< 0.1%
15.69	1	< 0.1%
15.75	1	< 0.1%
15.76	1	< 0.1%
15.91	1	< 0.1%
16.08	1	< 0.1%
16.31	1	< 0.1%
16.47	1	< 0.1%
16.73	1	< 0.1%
16.85	1	< 0.1%

Value	Count	Frequency (%)
1305.19	1	< 0.1%
1302.69	1	< 0.1%
1295.21	1	< 0.1%
1288.1	2	< 0.1%
1283.5	1	< 0.1%
1276.6	3	< 0.1%
1272.2	1	< 0.1%
1269.73	5	< 0.1%
1265.16	1	< 0.1%
1263.23	1	< 0.1%

emp_length
Categorical

MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	993
Missing (%)	2.6%
Memory size	300.7 KiB

10+ years	8464
< 1 year	4564
2 years	4292
3 years	3939
4 years	3314
Other values (6)	12912

Length

Max length	9
Median length	7
Mean length	7.4865413
Min length	6

Characters and Unicode

Total characters	280633
Distinct characters	18
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4 years
2nd row	4 years
3rd row	10+ years
4th row	10+ years
5th row	10+ years

Common Values

Value	Count	Frequency (%)
10+ years	8464	22.0%
< 1 year	4564	11.9%
2 years	4292	11.2%
3 years	3939	10.2%
4 years	3314	8.6%
1 year	3254	8.5%
5 years	3171	8.2%
6 years	2144	5.6%
7 years	1702	4.4%
8 years	1445	3.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
years	29667	37.3%
10	8464	10.6%
1	7818	9.8%
year	7818	9.8%
	4564	5.7%
2	4292	5.4%
3	3939	5.0%
4	3314	4.2%
5	3171	4.0%
6	2144	2.7%
Other values (3)	4343	5.5%

Most occurring characters

Value	Count	Frequency (%)
	42049	15.0%
y	37485	13.4%
e	37485	13.4%
a	37485	13.4%
r	37485	13.4%
s	29667	10.6%
1	16282	5.8%
0	8464	3.0%
+	8464	3.0%
<	4564	1.6%
Other values (8)	21203	7.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	179607	64.0%
Decimal Number	45949	16.4%
Space Separator	42049	15.0%
Math Symbol	13028	4.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	16282	35.4%
0	8464	18.4%
2	4292	9.3%
3	3939	8.6%
4	3314	7.2%
5	3171	6.9%
6	2144	4.7%
7	1702	3.7%
8	1445	3.1%
9	1196	2.6%

Lowercase Letter

Value	Count	Frequency (%)
y	37485	20.9%
e	37485	20.9%
a	37485	20.9%
r	37485	20.9%
s	29667	16.5%

Math Symbol

Value	Count	Frequency (%)
+	8464	65.0%
<	4564	35.0%

Space Separator

Value	Count	Frequency (%)
	42049	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	179607	64.0%
Common	101026	36.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
	42049	41.6%
1	16282	16.1%
0	8464	8.4%
+	8464	8.4%
<	4564	4.5%
2	4292	4.2%
3	3939	3.9%
4	3314	3.3%
5	3171	3.1%
6	2144	2.1%
Other values (3)	4343	4.3%

Latin

Value	Count	Frequency (%)
y	37485	20.9%
e	37485	20.9%
a	37485	20.9%
r	37485	20.9%
s	29667	16.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	280633	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	42049	15.0%
y	37485	13.4%
e	37485	13.4%
a	37485	13.4%
r	37485	13.4%
s	29667	10.6%
1	16282	5.8%
0	8464	3.0%
+	8464	3.0%
<	4564	1.6%
Other values (8)	21203	7.6%

home_ownership
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

RENT	18252
MORTGAGE	17139
OWN	2958
OTHER	125
NONE	4

Length

Max length	8
Median length	5
Mean length	5.7080669
Min length	3

Characters and Unicode

Total characters	219635
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENT
2nd row	RENT
3rd row	MORTGAGE
4th row	RENT
5th row	MORTGAGE

Common Values

Value	Count	Frequency (%)
RENT	18252	47.4%
MORTGAGE	17139	44.5%
OWN	2958	7.7%
OTHER	125	0.3%
NONE	4	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
rent	18252	47.4%
mortgage	17139	44.5%
own	2958	7.7%
other	125	0.3%
none	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	35520	16.2%
R	35516	16.2%
T	35516	16.2%
G	34278	15.6%
N	21218	9.7%
O	20226	9.2%
M	17139	7.8%
A	17139	7.8%
W	2958	1.3%
H	125	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	219635	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	35520	16.2%
R	35516	16.2%
T	35516	16.2%
G	34278	15.6%
N	21218	9.7%
O	20226	9.2%
M	17139	7.8%
A	17139	7.8%
W	2958	1.3%
H	125	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	219635	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	35520	16.2%
R	35516	16.2%
T	35516	16.2%
G	34278	15.6%
N	21218	9.7%
O	20226	9.2%
M	17139	7.8%
A	17139	7.8%
W	2958	1.3%
H	125	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	219635	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	35520	16.2%
R	35516	16.2%
T	35516	16.2%
G	34278	15.6%
N	21218	9.7%
O	20226	9.2%
M	17139	7.8%
A	17139	7.8%
W	2958	1.3%
H	125	0.1%

annual_inc
Real number (ℝ)

SKEWED

Distinct	5190
Distinct (%)	13.5%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	68997.102

Minimum	1896
Maximum	6000000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	1896
5-th percentile	24000
Q1	40000
median	58650
Q3	82000
95-th percentile	144000
Maximum	6000000
Range	5998104
Interquartile range (IQR)	42000

Descriptive statistics

Standard deviation	64476.267
Coefficient of variation (CV)	0.9344779
Kurtosis	2264.8897
Mean	68997.102
Median Absolute Deviation (MAD)	19922.88
Skewness	30.55624
Sum	2.6548015 × 10⁹
Variance	4.157189 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60000	1440	3.7%
50000	1018	2.6%
40000	857	2.2%
45000	830	2.2%
30000	810	2.1%
75000	781	2.0%
65000	760	2.0%
70000	726	1.9%
48000	693	1.8%
80000	644	1.7%
Other values (5180)	29918	77.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1896	1	< 0.1%
2000	1	< 0.1%
3300	1	< 0.1%
3500	1	< 0.1%
3600	1	< 0.1%
4000	3	< 0.1%
4080	1	< 0.1%
4200	2	< 0.1%
4800	5	< 0.1%
4888	1	< 0.1%

Value	Count	Frequency (%)
6000000	1	< 0.1%
3900000	1	< 0.1%
2039784	1	< 0.1%
1782000	1	< 0.1%
1440000	2	< 0.1%
1362000	1	< 0.1%
1250000	1	< 0.1%
1200000	3	< 0.1%
1176000	1	< 0.1%
1080000	1	< 0.1%

verification_status
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

Not Verified	16961
Verified	12169
Source Verified	9348

Length

Max length	15
Median length	12
Mean length	11.463797
Min length	8

Characters and Unicode

Total characters	441104
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Not Verified
2nd row	Not Verified
3rd row	Not Verified
4th row	Not Verified
5th row	Not Verified

Common Values

Value	Count	Frequency (%)
Not Verified	16961	44.1%
Verified	12169	31.6%
Source Verified	9348	24.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
verified	38478	59.4%
not	16961	26.2%
source	9348	14.4%

Most occurring characters

Value	Count	Frequency (%)
e	86304	19.6%
i	76956	17.4%
r	47826	10.8%
V	38478	8.7%
f	38478	8.7%
d	38478	8.7%
o	26309	6.0%
	26309	6.0%
N	16961	3.8%
t	16961	3.8%
Other values (3)	28044	6.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	350008	79.3%
Uppercase Letter	64787	14.7%
Space Separator	26309	6.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	86304	24.7%
i	76956	22.0%
r	47826	13.7%
f	38478	11.0%
d	38478	11.0%
o	26309	7.5%
t	16961	4.8%
u	9348	2.7%
c	9348	2.7%

Uppercase Letter

Value	Count	Frequency (%)
V	38478	59.4%
N	16961	26.2%
S	9348	14.4%

Space Separator

Value	Count	Frequency (%)
	26309	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	414795	94.0%
Common	26309	6.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	86304	20.8%
i	76956	18.6%
r	47826	11.5%
V	38478	9.3%
f	38478	9.3%
d	38478	9.3%
o	26309	6.3%
N	16961	4.1%
t	16961	4.1%
S	9348	2.3%
Other values (2)	18696	4.5%

Common

Value	Count	Frequency (%)
	26309	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	441104	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	86304	19.6%
i	76956	17.4%
r	47826	10.8%
V	38478	8.7%
f	38478	8.7%
d	38478	8.7%
o	26309	6.0%
	26309	6.0%
N	16961	3.8%
t	16961	3.8%
Other values (3)	28044	6.4%

issue_d
Text

Distinct	55
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	230868
Distinct characters	28
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jul-10
2nd row	Jun-10
3rd row	Sep-11
4th row	Sep-11
5th row	Apr-10

Value	Count	Frequency (%)
nov-11	2068	5.4%
dec-11	2056	5.3%
oct-11	1922	5.0%
sep-11	1852	4.8%
aug-11	1745	4.5%
jul-11	1672	4.3%
jun-11	1644	4.3%
may-11	1544	4.0%
apr-11	1405	3.7%
mar-11	1300	3.4%
Other values (45)	21270	55.3%

Most occurring characters

Value	Count	Frequency (%)
1	50640	21.9%
-	38478	16.7%
0	18831	8.2%
e	10073	4.4%
u	9822	4.3%
J	8839	3.8%
c	8044	3.5%
a	7954	3.4%
p	6249	2.7%
A	6134	2.7%
Other values (18)	65804	28.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76956	33.3%
Lowercase Letter	76956	33.3%
Dash Punctuation	38478	16.7%
Uppercase Letter	38478	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10073	13.1%
u	9822	12.8%
c	8044	10.5%
a	7954	10.3%
p	6249	8.1%
n	5503	7.2%
r	5479	7.1%
o	4052	5.3%
v	4052	5.3%
t	3804	4.9%
Other values (4)	11924	15.5%

Uppercase Letter

Value	Count	Frequency (%)
J	8839	23.0%
A	6134	15.9%
M	5576	14.5%
D	4240	11.0%
N	4052	10.5%
O	3804	9.9%
S	3476	9.0%
F	2357	6.1%

Decimal Number

Value	Count	Frequency (%)
1	50640	65.8%
0	18831	24.5%
9	4804	6.2%
8	2167	2.8%
7	514	0.7%

Dash Punctuation

Value	Count	Frequency (%)
-	38478	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115434	50.0%
Latin	115434	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10073	8.7%
u	9822	8.5%
J	8839	7.7%
c	8044	7.0%
a	7954	6.9%
p	6249	5.4%
A	6134	5.3%
M	5576	4.8%
n	5503	4.8%
r	5479	4.7%
Other values (12)	41761	36.2%

Common

Value	Count	Frequency (%)
1	50640	43.9%
-	38478	33.3%
0	18831	16.3%
9	4804	4.2%
8	2167	1.9%
7	514	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	230868	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	50640	21.9%
-	38478	16.7%
0	18831	8.2%
e	10073	4.4%
u	9822	4.3%
J	8839	3.8%
c	8044	3.5%
a	7954	3.4%
p	6249	2.7%
A	6134	2.7%
Other values (18)	65804	28.5%

loan_status
Categorical

HIGH CORRELATION IMBALANCE

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

Fully Paid	29987
Charged Off	5110
Does not meet the credit policy. Status:Fully Paid	1782
Current	866
Does not meet the credit policy. Status:Charged Off	689
Other values (4)	44

Length

Max length	51
Median length	10
Mean length	12.659156
Min length	7

Characters and Unicode

Total characters	487099
Distinct characters	38
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Does not meet the credit policy. Status:Fully Paid
2nd row	Charged Off
3rd row	Fully Paid
4th row	Fully Paid
5th row	Does not meet the credit policy. Status:Fully Paid

Common Values

Value	Count	Frequency (%)
Fully Paid	29987	77.9%
Charged Off	5110	13.3%
Does not meet the credit policy. Status:Fully Paid	1782	4.6%
Current	866	2.3%
Does not meet the credit policy. Status:Charged Off	689	1.8%
Late (31-120 days)	20	0.1%
In Grace Period	15	< 0.1%
Late (16-30 days)	7	< 0.1%
Default	2	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
paid	31769	34.9%
fully	29987	33.0%
off	5799	6.4%
charged	5110	5.6%
does	2471	2.7%
not	2471	2.7%
meet	2471	2.7%
the	2471	2.7%
credit	2471	2.7%
policy	2471	2.7%
Other values (11)	3465	3.8%

Most occurring characters

Value	Count	Frequency (%)
l	66011	13.6%
	52478	10.8%
a	40110	8.2%
d	40081	8.2%
i	36726	7.5%
u	35108	7.2%
y	34267	7.0%
P	31784	6.5%
F	31769	6.5%
e	19079	3.9%
Other values (28)	99686	20.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	348452	71.5%
Uppercase Letter	81018	16.6%
Space Separator	52478	10.8%
Other Punctuation	4942	1.0%
Decimal Number	128	< 0.1%
Dash Punctuation	27	< 0.1%
Close Punctuation	27	< 0.1%
Open Punctuation	27	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	66011	18.9%
a	40110	11.5%
d	40081	11.5%
i	36726	10.5%
u	35108	10.1%
y	34267	9.8%
e	19079	5.5%
t	15721	4.5%
f	11600	3.3%
r	10032	2.9%
Other values (8)	39717	11.4%

Uppercase Letter

Value	Count	Frequency (%)
P	31784	39.2%
F	31769	39.2%
C	6665	8.2%
O	5799	7.2%
D	2473	3.1%
S	2471	3.0%
L	27	< 0.1%
I	15	< 0.1%
G	15	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	47	36.7%
0	27	21.1%
3	27	21.1%
2	20	15.6%
6	7	5.5%

Other Punctuation

Value	Count	Frequency (%)
.	2471	50.0%
:	2471	50.0%

Space Separator

Value	Count	Frequency (%)
	52478	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	27	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	27	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	27	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	429470	88.2%
Common	57629	11.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	66011	15.4%
a	40110	9.3%
d	40081	9.3%
i	36726	8.6%
u	35108	8.2%
y	34267	8.0%
P	31784	7.4%
F	31769	7.4%
e	19079	4.4%
t	15721	3.7%
Other values (17)	78814	18.4%

Common

Value	Count	Frequency (%)
	52478	91.1%
.	2471	4.3%
:	2471	4.3%
1	47	0.1%
-	27	< 0.1%
)	27	< 0.1%
0	27	< 0.1%
3	27	< 0.1%
(	27	< 0.1%
2	20	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	487099	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	66011	13.6%
	52478	10.8%
a	40110	8.2%
d	40081	8.2%
i	36726	7.5%
u	35108	7.2%
y	34267	7.0%
P	31784	6.5%
F	31769	6.5%
e	19079	3.9%
Other values (28)	99686	20.5%

purpose
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

debt_consolidation	17917
credit_card	4973
other	3950
home_improvement	2901
major_purchase	2078
Other values (9)	6659

Length

Max length	18
Median length	16
Mean length	13.70131
Min length	3

Characters and Unicode

Total characters	527199
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	other
2nd row	debt_consolidation
3rd row	other
4th row	debt_consolidation
5th row	other

Common Values

Value	Count	Frequency (%)
debt_consolidation	17917	46.6%
credit_card	4973	12.9%
other	3950	10.3%
home_improvement	2901	7.5%
major_purchase	2078	5.4%
small_business	1808	4.7%
car	1481	3.8%
wedding	909	2.4%
medical	675	1.8%
moving	562	1.5%
Other values (4)	1224	3.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
debt_consolidation	17917	46.6%
credit_card	4973	12.9%
other	3950	10.3%
home_improvement	2901	7.5%
major_purchase	2078	5.4%
small_business	1808	4.7%
car	1481	3.8%
wedding	909	2.4%
medical	675	1.8%
moving	562	1.5%
Other values (4)	1224	3.2%

Most occurring characters

Value	Count	Frequency (%)
o	67276	12.8%
d	48659	9.2%
i	48408	9.2%
t	48404	9.2%
n	42942	8.1%
e	42241	8.0%
c	32843	6.2%
a	32593	6.2%
_	29768	5.6%
s	27614	5.2%
Other values (12)	106451	20.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	497431	94.4%
Connector Punctuation	29768	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	67276	13.5%
d	48659	9.8%
i	48408	9.7%
t	48404	9.7%
n	42942	8.6%
e	42241	8.5%
c	32843	6.6%
a	32593	6.6%
s	27614	5.6%
l	22685	4.6%
Other values (11)	83766	16.8%

Connector Punctuation

Value	Count	Frequency (%)
_	29768	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	497431	94.4%
Common	29768	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	67276	13.5%
d	48659	9.8%
i	48408	9.7%
t	48404	9.7%
n	42942	8.6%
e	42241	8.5%
c	32843	6.6%
a	32593	6.6%
s	27614	5.6%
l	22685	4.6%
Other values (11)	83766	16.8%

Common

Value	Count	Frequency (%)
_	29768	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	527199	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	67276	12.8%
d	48659	9.2%
i	48408	9.2%
t	48404	9.2%
n	42942	8.1%
e	42241	8.0%
c	32843	6.2%
a	32593	6.2%
_	29768	5.6%
s	27614	5.2%
Other values (12)	106451	20.2%

zip_code
Text

Distinct	832
Distinct (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	192390
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	0.1%

Sample

1st row	487xx
2nd row	115xx
3rd row	751xx
4th row	112xx
5th row	352xx

Value	Count	Frequency (%)
100xx	573	1.5%
945xx	502	1.3%
606xx	499	1.3%
112xx	492	1.3%
070xx	447	1.2%
900xx	438	1.1%
300xx	395	1.0%
021xx	375	1.0%
750xx	362	0.9%
926xx	354	0.9%
Other values (822)	34041	88.5%

Most occurring characters

Value	Count	Frequency (%)
x	76956	40.0%
0	19159	10.0%
1	15128	7.9%
2	13067	6.8%
9	12179	6.3%
3	12075	6.3%
7	9870	5.1%
4	8824	4.6%
5	8804	4.6%
8	8445	4.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	115434	60.0%
Lowercase Letter	76956	40.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19159	16.6%
1	15128	13.1%
2	13067	11.3%
9	12179	10.6%
3	12075	10.5%
7	9870	8.6%
4	8824	7.6%
5	8804	7.6%
8	8445	7.3%
6	7883	6.8%

Lowercase Letter

Value	Count	Frequency (%)
x	76956	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115434	60.0%
Latin	76956	40.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19159	16.6%
1	15128	13.1%
2	13067	11.3%
9	12179	10.6%
3	12075	10.5%
7	9870	8.6%
4	8824	7.6%
5	8804	7.6%
8	8445	7.3%
6	7883	6.8%

Latin

Value	Count	Frequency (%)
x	76956	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	192390	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
x	76956	40.0%
0	19159	10.0%
1	15128	7.9%
2	13067	6.8%
9	12179	6.3%
3	12075	6.3%
7	9870	5.1%
4	8824	4.6%
5	8804	4.6%
8	8445	4.4%

addr_state
Categorical

Distinct	50
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

CA	6754
NY	3702
FL	2803
TX	2633
NJ	1795
Other values (45)	20791

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	76956
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MI
2nd row	NY
3rd row	TX
4th row	NY
5th row	AL

Common Values

Value	Count	Frequency (%)
CA	6754	17.6%
NY	3702	9.6%
FL	2803	7.3%
TX	2633	6.8%
NJ	1795	4.7%
IL	1523	4.0%
PA	1491	3.9%
GA	1371	3.6%
VA	1343	3.5%
MA	1285	3.3%
Other values (40)	13778	35.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	6754	17.6%
ny	3702	9.6%
fl	2803	7.3%
tx	2633	6.8%
nj	1795	4.7%
il	1523	4.0%
pa	1491	3.9%
ga	1371	3.6%
va	1343	3.5%
ma	1285	3.3%
Other values (40)	13778	35.8%

Most occurring characters

Value	Count	Frequency (%)
A	15079	19.6%
C	9628	12.5%
N	7741	10.1%
L	5180	6.7%
M	4578	5.9%
Y	4093	5.3%
T	3779	4.9%
O	3360	4.4%
I	3097	4.0%
F	2803	3.6%
Other values (14)	17618	22.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	76956	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	15079	19.6%
C	9628	12.5%
N	7741	10.1%
L	5180	6.7%
M	4578	5.9%
Y	4093	5.3%
T	3779	4.9%
O	3360	4.4%
I	3097	4.0%
F	2803	3.6%
Other values (14)	17618	22.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	76956	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	15079	19.6%
C	9628	12.5%
N	7741	10.1%
L	5180	6.7%
M	4578	5.9%
Y	4093	5.3%
T	3779	4.9%
O	3360	4.4%
I	3097	4.0%
F	2803	3.6%
Other values (14)	17618	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	76956	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	15079	19.6%
C	9628	12.5%
N	7741	10.1%
L	5180	6.7%
M	4578	5.9%
Y	4093	5.3%
T	3779	4.9%
O	3360	4.4%
I	3097	4.0%
F	2803	3.6%
Other values (14)	17618	22.9%

dti
Real number (ℝ)

Distinct	2877
Distinct (%)	7.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.376215

Minimum	0
Maximum	29.99
Zeros	190
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	2.1
Q1	8.2
median	13.485
Q3	18.69
95-th percentile	23.92
Maximum	29.99
Range	29.99
Interquartile range (IQR)	10.49

Descriptive statistics

Standard deviation	6.7297127
Coefficient of variation (CV)	0.50311038
Kurtosis	-0.85284363
Mean	13.376215
Median Absolute Deviation (MAD)	5.235
Skewness	-0.0310279
Sum	514690.01
Variance	45.289033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	190	0.5%
12	44	0.1%
18	42	0.1%
16.8	39	0.1%
19.2	39	0.1%
13.2	39	0.1%
12.48	38	0.1%
4.8	35	0.1%
15	35	0.1%
13.5	34	0.1%
Other values (2867)	37943	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	190	0.5%
0.01	3	< 0.1%
0.02	5	< 0.1%
0.03	2	< 0.1%
0.04	3	< 0.1%
0.05	2	< 0.1%
0.06	1	< 0.1%
0.07	4	< 0.1%
0.08	5	< 0.1%
0.09	4	< 0.1%

Value	Count	Frequency (%)
29.99	1	< 0.1%
29.96	1	< 0.1%
29.95	1	< 0.1%
29.93	3	< 0.1%
29.92	2	< 0.1%
29.89	1	< 0.1%
29.88	1	< 0.1%
29.86	2	< 0.1%
29.85	1	< 0.1%
29.83	1	< 0.1%

delinq_2yrs
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.15193097

Minimum	0
Maximum	11
Zeros	34200
Zeros (%)	88.9%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	11
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.5075978
Coefficient of variation (CV)	3.3409764
Kurtosis	42.56804
Mean	0.15193097
Median Absolute Deviation (MAD)	0
Skewness	5.1435969
Sum	5846
Variance	0.25765552
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	34200	88.9%
1	3244	8.4%
2	700	1.8%
3	224	0.6%
4	62	0.2%
5	26	0.1%
6	13	< 0.1%
7	5	< 0.1%
11	2	< 0.1%
9	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	34200	88.9%
1	3244	8.4%
2	700	1.8%
3	224	0.6%
4	62	0.2%
5	26	0.1%
6	13	< 0.1%
7	5	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
11	2	< 0.1%
9	1	< 0.1%
8	1	< 0.1%
7	5	< 0.1%
6	13	< 0.1%
5	26	0.1%
4	62	0.2%
3	224	0.6%
2	700	1.8%
1	3244	8.4%

earliest_cr_line
Text

Distinct	528
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	230868
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	35 ?
Unique (%)	0.1%

Sample

1st row	Aug-05
2nd row	Apr-94
3rd row	Mar-98
4th row	Jan-75
5th row	Apr-98

Value	Count	Frequency (%)
nov-98	352	0.9%
oct-99	351	0.9%
oct-00	339	0.9%
dec-98	326	0.8%
nov-99	314	0.8%
nov-00	311	0.8%
dec-97	305	0.8%
sep-00	301	0.8%
oct-98	296	0.8%
nov-97	288	0.7%
Other values (518)	35295	91.7%

Most occurring characters

Value	Count	Frequency (%)
-	38478	16.7%
9	22596	9.8%
0	18766	8.1%
e	10137	4.4%
J	9143	4.0%
u	8997	3.9%
a	8870	3.8%
8	8151	3.5%
c	7826	3.4%
p	6192	2.7%
Other values (23)	91712	39.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76956	33.3%
Lowercase Letter	76956	33.3%
Dash Punctuation	38478	16.7%
Uppercase Letter	38478	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10137	13.2%
u	8997	11.7%
a	8870	11.5%
c	7826	10.2%
p	6192	8.0%
n	6164	8.0%
r	5411	7.0%
t	3961	5.1%
o	3815	5.0%
v	3815	5.0%
Other values (4)	11768	15.3%

Decimal Number

Value	Count	Frequency (%)
9	22596	29.4%
0	18766	24.4%
8	8151	10.6%
7	4652	6.0%
4	4127	5.4%
6	4124	5.4%
5	4087	5.3%
3	3656	4.8%
1	3610	4.7%
2	3187	4.1%

Uppercase Letter

Value	Count	Frequency (%)
J	9143	23.8%
A	5889	15.3%
M	5533	14.4%
O	3961	10.3%
D	3865	10.0%
N	3815	9.9%
S	3494	9.1%
F	2778	7.2%

Dash Punctuation

Value	Count	Frequency (%)
-	38478	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115434	50.0%
Latin	115434	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10137	8.8%
J	9143	7.9%
u	8997	7.8%
a	8870	7.7%
c	7826	6.8%
p	6192	5.4%
n	6164	5.3%
A	5889	5.1%
M	5533	4.8%
r	5411	4.7%
Other values (12)	41272	35.8%

Common

Value	Count	Frequency (%)
-	38478	33.3%
9	22596	19.6%
0	18766	16.3%
8	8151	7.1%
7	4652	4.0%
4	4127	3.6%
6	4124	3.6%
5	4087	3.5%
3	3656	3.2%
1	3610	3.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	230868	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	38478	16.7%
9	22596	9.8%
0	18766	8.1%
e	10137	4.4%
J	9143	4.0%
u	8997	3.9%
a	8870	3.8%
8	8151	3.5%
c	7826	3.4%
p	6192	2.7%
Other values (23)	91712	39.7%

inq_last_6mths
Real number (ℝ)

ZEROS

Distinct	28
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.0839701

Minimum	0
Maximum	33
Zeros	17787
Zeros (%)	46.2%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	4
Maximum	33
Range	33
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.5348241
Coefficient of variation (CV)	1.4159285
Kurtosis	32.588372
Mean	1.0839701
Median Absolute Deviation (MAD)	1
Skewness	3.5358174
Sum	41709
Variance	2.355685
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	17787	46.2%
1	10149	26.4%
2	5452	14.2%
3	2878	7.5%
4	955	2.5%
5	551	1.4%
6	304	0.8%
7	165	0.4%
8	104	0.3%
9	45	0.1%
Other values (18)	88	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	17787	46.2%
1	10149	26.4%
2	5452	14.2%
3	2878	7.5%
4	955	2.5%
5	551	1.4%
6	304	0.8%
7	165	0.4%
8	104	0.3%
9	45	0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
32	1	< 0.1%
31	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
25	1	< 0.1%
24	2	< 0.1%
20	1	< 0.1%
19	2	< 0.1%
18	4	< 0.1%

mths_since_last_delinq
Real number (ℝ)

HIGH CORRELATION MISSING ZEROS

Distinct	93
Distinct (%)	0.7%
Missing	24362
Missing (%)	63.3%
Infinite	0
Infinite (%)	0.0%
Mean	35.012326

Minimum	0
Maximum	120
Zeros	745
Zeros (%)	1.9%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	17
median	33
Q3	51
95-th percentile	75
Maximum	120
Range	120
Interquartile range (IQR)	34

Descriptive statistics

Standard deviation	22.425701
Coefficient of variation (CV)	0.64050874
Kurtosis	-0.86678787
Mean	35.012326
Median Absolute Deviation (MAD)	17
Skewness	0.29878963
Sum	494234
Variance	502.91207
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	745	1.9%
30	246	0.6%
19	242	0.6%
15	238	0.6%
24	235	0.6%
23	234	0.6%
18	232	0.6%
38	224	0.6%
20	223	0.6%
31	222	0.6%
Other values (83)	11275	29.3%
(Missing)	24362	63.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	745	1.9%
1	30	0.1%
2	106	0.3%
3	143	0.4%
4	153	0.4%
5	145	0.4%
6	202	0.5%
7	184	0.5%
8	169	0.4%
9	175	0.5%

Value	Count	Frequency (%)
120	1	< 0.1%
115	1	< 0.1%
106	1	< 0.1%
103	1	< 0.1%
96	1	< 0.1%
95	1	< 0.1%
89	1	< 0.1%
86	2	< 0.1%
85	1	< 0.1%
83	5	< 0.1%

open_acc
Real number (ℝ)

HIGH CORRELATION

Distinct	43
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.3432091

Minimum	1
Maximum	47
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	6
median	9
Q3	12
95-th percentile	18
Maximum	47
Range	46
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.4978809
Coefficient of variation (CV)	0.48140642
Kurtosis	1.8739804
Mean	9.3432091
Median Absolute Deviation (MAD)	3
Skewness	1.0385054
Sum	359508
Variance	20.230932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
7	3847	10.0%
8	3778	9.8%
6	3756	9.8%
9	3547	9.2%
5	3086	8.0%
10	3059	7.9%
11	2686	7.0%
4	2268	5.9%
12	2167	5.6%
13	1864	4.8%
Other values (33)	8420	21.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	34	0.1%
2	631	1.6%
3	1447	3.8%
4	2268	5.9%
5	3086	8.0%
6	3756	9.8%
7	3847	10.0%
8	3778	9.8%
9	3547	9.2%
10	3059	7.9%

Value	Count	Frequency (%)
47	1	< 0.1%
44	1	< 0.1%
42	1	< 0.1%
41	1	< 0.1%
39	1	< 0.1%
38	2	< 0.1%
37	1	< 0.1%
36	1	< 0.1%
35	2	< 0.1%
34	8	< 0.1%

pub_rec
Real number (ℝ)

ZEROS

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.057903217

Minimum	0
Maximum	5
Zeros	36339
Zeros (%)	94.4%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.24571022
Coefficient of variation (CV)	4.243464
Kurtosis	27.978845
Mean	0.057903217
Median Absolute Deviation (MAD)	0
Skewness	4.665772
Sum	2228
Variance	0.060373512
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	36339	94.4%
1	2068	5.4%
2	57	0.1%
3	11	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	36339	94.4%
1	2068	5.4%
2	57	0.1%
3	11	< 0.1%
4	2	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
5	1	< 0.1%
4	2	< 0.1%
3	11	< 0.1%
2	57	0.1%
1	2068	5.4%
0	36339	94.4%

revol_bal
Real number (ℝ)

ZEROS

Distinct	21470
Distinct (%)	55.8%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	14290.238

Minimum	0
Maximum	1207359
Zeros	976
Zeros (%)	2.5%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	300
Q1	3640
median	8840
Q3	17266
95-th percentile	44323.3
Maximum	1207359
Range	1207359
Interquartile range (IQR)	13626

Descriptive statistics

Standard deviation	21941.541
Coefficient of variation (CV)	1.5354217
Kurtosis	368.45607
Mean	14290.238
Median Absolute Deviation (MAD)	6096
Skewness	11.258751
Sum	5.498169 × 10⁸
Variance	4.8143124 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	976	2.5%
255	14	< 0.1%
298	14	< 0.1%
400	10	< 0.1%
52	10	< 0.1%
6	10	< 0.1%
1	10	< 0.1%
182	9	< 0.1%
2725	9	< 0.1%
346	9	< 0.1%
Other values (21460)	37404	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	976	2.5%
1	10	< 0.1%
2	6	< 0.1%
3	7	< 0.1%
4	3	< 0.1%
5	6	< 0.1%
6	10	< 0.1%
7	5	< 0.1%
8	4	< 0.1%
9	8	< 0.1%

Value	Count	Frequency (%)
1207359	1	< 0.1%
952013	1	< 0.1%
508961	1	< 0.1%
487589	1	< 0.1%
423189	1	< 0.1%
407794	1	< 0.1%
401941	1	< 0.1%
394107	1	< 0.1%
388892	1	< 0.1%
385489	1	< 0.1%

revol_util
Text

Distinct	1107
Distinct (%)	2.9%
Missing	59
Missing (%)	0.2%
Memory size	300.7 KiB

Length

Max length	7
Median length	6
Mean length	5.5226581
Min length	2

Characters and Unicode

Total characters	212175
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	103 ?
Unique (%)	0.3%

Sample

1st row	21.30%
2nd row	99.90%
3rd row	47.20%
4th row	0%
5th row	0%

Value	Count	Frequency (%)
0	949	2.5%
0.10	60	0.2%
0.20	60	0.2%
70.40	59	0.2%
35.30	57	0.1%
31.20	55	0.1%
76.60	55	0.1%
46.60	55	0.1%
37.60	55	0.1%
70.10	54	0.1%
Other values (1097)	36960	96.2%

Most occurring characters

Value	Count	Frequency (%)
0	38435	18.1%
%	38419	18.1%
.	33725	15.9%
4	11720	5.5%
7	11656	5.5%
5	11595	5.5%
6	11581	5.5%
3	11499	5.4%
2	11199	5.3%
8	11080	5.2%
Other values (2)	21266	10.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	140031	66.0%
Other Punctuation	72144	34.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	38435	27.4%
4	11720	8.4%
7	11656	8.3%
5	11595	8.3%
6	11581	8.3%
3	11499	8.2%
2	11199	8.0%
8	11080	7.9%
1	10725	7.7%
9	10541	7.5%

Other Punctuation

Value	Count	Frequency (%)
%	38419	53.3%
.	33725	46.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	212175	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	38435	18.1%
%	38419	18.1%
.	33725	15.9%
4	11720	5.5%
7	11656	5.5%
5	11595	5.5%
6	11581	5.5%
3	11499	5.4%
2	11199	5.3%
8	11080	5.2%
Other values (2)	21266	10.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	212175	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	38435	18.1%
%	38419	18.1%
.	33725	15.9%
4	11720	5.5%
7	11656	5.5%
5	11595	5.5%
6	11581	5.5%
3	11499	5.4%
2	11199	5.3%
8	11080	5.2%
Other values (2)	21266	10.0%

total_acc
Real number (ℝ)

HIGH CORRELATION

Distinct	81
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.109049

Minimum	1
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	13
median	20
Q3	29
95-th percentile	44
Maximum	90
Range	89
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	11.588253
Coefficient of variation (CV)	0.52414073
Kurtosis	0.65524708
Mean	22.109049
Median Absolute Deviation (MAD)	8
Skewness	0.82306414
Sum	850712
Variance	134.28761
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15	1423	3.7%
16	1408	3.7%
14	1387	3.6%
17	1385	3.6%
18	1362	3.5%
20	1351	3.5%
13	1342	3.5%
21	1335	3.5%
12	1286	3.3%
19	1276	3.3%
Other values (71)	24923	64.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	19	< 0.1%
2	34	0.1%
3	220	0.6%
4	438	1.1%
5	571	1.5%
6	691	1.8%
7	814	2.1%
8	967	2.5%
9	1032	2.7%
10	1142	3.0%

Value	Count	Frequency (%)
90	1	< 0.1%
87	1	< 0.1%
80	1	< 0.1%
79	2	< 0.1%
77	1	< 0.1%
76	2	< 0.1%
75	2	< 0.1%
74	1	< 0.1%
73	3	< 0.1%
72	1	< 0.1%

total_pymnt
Real number (ℝ)

HIGH CORRELATION

Distinct	36820
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11981.008

Minimum	0
Maximum	58563.68
Zeros	20
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1803.9849
Q1	5463.1711
median	9673.6349
Q3	16402.677
95-th percentile	30074.861
Maximum	58563.68
Range	58563.68
Interquartile range (IQR)	10939.506

Descriptive statistics

Standard deviation	9006.4151
Coefficient of variation (CV)	0.75172431
Kurtosis	2.0132894
Mean	11981.008
Median Absolute Deviation (MAD)	4976.349
Skewness	1.3476654
Sum	4.6100524 × 10⁸
Variance	81115514
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11196.56943	21	0.1%
0	20	0.1%
11784.23223	16	< 0.1%
10956.77596	15	< 0.1%
13148.13786	14	< 0.1%
5478.387981	14	< 0.1%
5557.025543	13	< 0.1%
13435.90021	12	< 0.1%
13263.95464	12	< 0.1%
4343.013754	10	< 0.1%
Other values (36810)	38331	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20	0.1%
35.71	1	< 0.1%
44.92	2	< 0.1%
44.96	1	< 0.1%
57.18	1	< 0.1%
61.71	1	< 0.1%
66.77	1	< 0.1%
67.32	1	< 0.1%
69.64	1	< 0.1%
69.77	1	< 0.1%

Value	Count	Frequency (%)
58563.67993	1	< 0.1%
58480.13992	1	< 0.1%
57835.27991	1	< 0.1%
56849.26986	1	< 0.1%
56199.43995	1	< 0.1%
55906.9499	1	< 0.1%
55768.77995	1	< 0.1%
55138.99996	1	< 0.1%
55106.27994	1	< 0.1%
54774.41992	1	< 0.1%

total_pymnt_inv
Real number (ℝ)

HIGH CORRELATION

Distinct	36374
Distinct (%)	94.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11274.813

Minimum	0
Maximum	58563.68
Zeros	261
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1169.3535
Q1	4811.98
median	8954.01
Q3	15486.997
95-th percentile	29440.615
Maximum	58563.68
Range	58563.68
Interquartile range (IQR)	10675.017

Descriptive statistics

Standard deviation	8946.1616
Coefficient of variation (CV)	0.79346432
Kurtosis	2.0559067
Mean	11274.813
Median Absolute Deviation (MAD)	4960.4
Skewness	1.3624561
Sum	4.3383224 × 10⁸
Variance	80033806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	261	0.7%
6514.52	14	< 0.1%
5478.39	13	< 0.1%
13148.14	13	< 0.1%
10956.78	12	< 0.1%
6717.95	12	< 0.1%
5557.03	11	< 0.1%
13517.36	11	< 0.1%
11784.23	10	< 0.1%
7328.92	10	< 0.1%
Other values (36364)	38111	99.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	261	0.7%
0.51	1	< 0.1%
0.54	1	< 0.1%
0.92	1	< 0.1%
11.21	1	< 0.1%
12.65	1	< 0.1%
16.82	1	< 0.1%
18.97	1	< 0.1%
20.98	1	< 0.1%
21.6	1	< 0.1%

Value	Count	Frequency (%)
58563.68	1	< 0.1%
58438.37	1	< 0.1%
57628.73	1	< 0.1%
56515.16	1	< 0.1%
55867.02	1	< 0.1%
55579.28	1	< 0.1%
55066.92	1	< 0.1%
54675.68	1	< 0.1%
54432.79	1	< 0.1%
54241.58	1	< 0.1%

total_rec_prncp
Real number (ℝ)

HIGH CORRELATION

Distinct	7907
Distinct (%)	20.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9646.6634

Minimum	0
Maximum	35000.02
Zeros	74
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1203.308
Q1	4400
median	8000
Q3	13317.515
95-th percentile	24250
Maximum	35000.02
Range	35000.02
Interquartile range (IQR)	8917.515

Descriptive statistics

Standard deviation	7051.7485
Coefficient of variation (CV)	0.73100389
Kurtosis	1.1031082
Mean	9646.6634
Median Absolute Deviation (MAD)	4000
Skewness	1.1221576
Sum	3.7118431 × 10⁸
Variance	49727156
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10000	2181	5.7%
12000	1729	4.5%
5000	1650	4.3%
6000	1565	4.1%
15000	1349	3.5%
8000	1281	3.3%
20000	1033	2.7%
4000	937	2.4%
3000	865	2.2%
7000	812	2.1%
Other values (7897)	25076	65.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	0.2%
21.21	1	< 0.1%
21.93	1	< 0.1%
23.68	1	< 0.1%
24.87	1	< 0.1%
30.32	1	< 0.1%
32.51	1	< 0.1%
34.5	1	< 0.1%
35.14	1	< 0.1%
35.8	1	< 0.1%

Value	Count	Frequency (%)
35000.02	1	< 0.1%
35000.01	1	< 0.1%
35000	333	0.9%
34999.99	4	< 0.1%
34999.98	1	< 0.1%
34999.97	1	< 0.1%
34800	1	< 0.1%
34675	1	< 0.1%
34525	1	< 0.1%
34475.01	1	< 0.1%

total_rec_int
Real number (ℝ)

HIGH CORRELATION

Distinct	34249
Distinct (%)	89.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2232.8263

Minimum	0
Maximum	23611.1
Zeros	71
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	185.617
Q1	657.7325
median	1335.09
Q3	2795.125
95-th percentile	7419.006
Maximum	23611.1
Range	23611.1
Interquartile range (IQR)	2137.3925

Descriptive statistics

Standard deviation	2570.1855
Coefficient of variation (CV)	1.1510907
Kurtosis	10.012057
Mean	2232.8263
Median Absolute Deviation (MAD)	854.82
Skewness	2.7014866
Sum	85914689
Variance	6605853.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	71	0.2%
1196.57	21	0.1%
1784.23	17	< 0.1%
514.52	17	< 0.1%
956.78	16	< 0.1%
717.95	16	< 0.1%
1148.14	16	< 0.1%
478.39	15	< 0.1%
1517.36	13	< 0.1%
557.03	13	< 0.1%
Other values (34239)	38263	99.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	71	0.2%
3.54	1	< 0.1%
6.22	1	< 0.1%
6.27	1	< 0.1%
7.19	1	< 0.1%
7.2	2	< 0.1%
8.06	1	< 0.1%
8.92	1	< 0.1%
9.34	1	< 0.1%
9.49	1	< 0.1%

Value	Count	Frequency (%)
23611.1	1	< 0.1%
23563.68	1	< 0.1%
23480.14	1	< 0.1%
22835.28	1	< 0.1%
22816.85	1	< 0.1%
22710.04	1	< 0.1%
22709.2	1	< 0.1%
22708.9	1	< 0.1%
22703.37	1	< 0.1%
22574.73	1	< 0.1%

last_pymnt_d
Text

Distinct	103
Distinct (%)	0.3%
Missing	71
Missing (%)	0.2%
Memory size	300.7 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	230442
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Jul-13
2nd row	Nov-11
3rd row	Mar-14
4th row	Feb-14
5th row	May-13

Value	Count	Frequency (%)
jun-16	1022	2.7%
mar-13	966	2.5%
dec-14	870	2.3%
may-13	856	2.2%
feb-13	808	2.1%
apr-13	806	2.1%
mar-12	801	2.1%
aug-12	798	2.1%
oct-12	781	2.0%
aug-14	758	2.0%
Other values (93)	29941	78.0%

Most occurring characters

Value	Count	Frequency (%)
1	42586	18.5%
-	38407	16.7%
u	10078	4.4%
J	9872	4.3%
a	9730	4.2%
e	9481	4.1%
3	8883	3.9%
2	8463	3.7%
4	8438	3.7%
M	6815	3.0%
Other values (23)	77689	33.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76814	33.3%
Lowercase Letter	76814	33.3%
Dash Punctuation	38407	16.7%
Uppercase Letter	38407	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	10078	13.1%
a	9730	12.7%
e	9481	12.3%
n	6783	8.8%
r	6761	8.8%
c	6582	8.6%
p	6000	7.8%
t	3186	4.1%
b	3161	4.1%
y	3130	4.1%
Other values (4)	11922	15.5%

Decimal Number

Value	Count	Frequency (%)
1	42586	55.4%
3	8883	11.6%
2	8463	11.0%
4	8438	11.0%
0	3237	4.2%
5	2264	2.9%
6	1887	2.5%
9	757	1.0%
8	297	0.4%
7	2	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
J	9872	25.7%
M	6815	17.7%
A	6197	16.1%
D	3396	8.8%
O	3186	8.3%
F	3161	8.2%
S	2924	7.6%
N	2856	7.4%

Dash Punctuation

Value	Count	Frequency (%)
-	38407	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115221	50.0%
Latin	115221	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
u	10078	8.7%
J	9872	8.6%
a	9730	8.4%
e	9481	8.2%
M	6815	5.9%
n	6783	5.9%
r	6761	5.9%
c	6582	5.7%
A	6197	5.4%
p	6000	5.2%
Other values (12)	36922	32.0%

Common

Value	Count	Frequency (%)
1	42586	37.0%
-	38407	33.3%
3	8883	7.7%
2	8463	7.3%
4	8438	7.3%
0	3237	2.8%
5	2264	2.0%
6	1887	1.6%
9	757	0.7%
8	297	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	230442	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	42586	18.5%
-	38407	16.7%
u	10078	4.4%
J	9872	4.3%
a	9730	4.2%
e	9481	4.1%
3	8883	3.9%
2	8463	3.7%
4	8438	3.7%
M	6815	3.0%
Other values (23)	77689	33.7%

last_pymnt_amnt
Real number (ℝ)

HIGH CORRELATION

Distinct	33868
Distinct (%)	88.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2614.5097

Minimum	0
Maximum	36115.2
Zeros	77
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	300.7 KiB

Quantile statistics

Minimum	0
5-th percentile	39.8855
Q1	212.0325
median	526.005
Q3	3169.9625
95-th percentile	12064.072
Maximum	36115.2
Range	36115.2
Interquartile range (IQR)	2957.93

Descriptive statistics

Standard deviation	4392.0064
Coefficient of variation (CV)	1.6798585
Kurtosis	9.1182667
Mean	2614.5097
Median Absolute Deviation (MAD)	430.445
Skewness	2.7470832
Sum	1.006011 × 10⁸
Variance	19289720
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	77	0.2%
276.06	17	< 0.1%
200	17	< 0.1%
50	16	< 0.1%
100	15	< 0.1%
150	13	< 0.1%
500	11	< 0.1%
773.44	10	< 0.1%
400	9	< 0.1%
280.91	9	< 0.1%
Other values (33858)	38284	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	77	0.2%
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.13	1	< 0.1%
0.16	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.28	1	< 0.1%

Value	Count	Frequency (%)
36115.2	1	< 0.1%
35613.68	1	< 0.1%
35596.41	1	< 0.1%
35479.89	1	< 0.1%
35471.86	1	< 0.1%
35395.59	1	< 0.1%
35339.05	1	< 0.1%
35337.09	1	< 0.1%
35322.96	1	< 0.1%
35322.6	1	< 0.1%

next_pymnt_d
Text

MISSING

Distinct	101
Distinct (%)	3.0%
Missing	35097
Missing (%)	91.2%
Memory size	300.7 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	20286
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	0.2%

Sample

1st row	Aug-13
2nd row	Jun-13
3rd row	Sep-10
4th row	Jan-12
5th row	Jul-11

Value	Count	Frequency (%)
jul-16	909	26.9%
mar-11	100	3.0%
apr-11	87	2.6%
feb-11	85	2.5%
jan-11	72	2.1%
dec-10	67	2.0%
may-11	65	1.9%
sep-11	59	1.7%
jun-11	58	1.7%
nov-10	51	1.5%
Other values (91)	1828	54.1%

Most occurring characters

Value	Count	Frequency (%)
1	3744	18.5%
-	3381	16.7%
J	1444	7.1%
u	1436	7.1%
l	1070	5.3%
6	919	4.5%
0	840	4.1%
a	651	3.2%
e	635	3.1%
c	494	2.4%
Other values (23)	5672	28.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6762	33.3%
Lowercase Letter	6762	33.3%
Dash Punctuation	3381	16.7%
Uppercase Letter	3381	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	1436	21.2%
l	1070	15.8%
a	651	9.6%
e	635	9.4%
c	494	7.3%
r	465	6.9%
p	398	5.9%
n	374	5.5%
t	232	3.4%
v	209	3.1%
Other values (4)	798	11.8%

Decimal Number

Value	Count	Frequency (%)
1	3744	55.4%
6	919	13.6%
0	840	12.4%
2	423	6.3%
3	335	5.0%
9	285	4.2%
8	90	1.3%
5	70	1.0%
4	55	0.8%
7	1	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
J	1444	42.7%
M	452	13.4%
A	409	12.1%
D	262	7.7%
O	232	6.9%
N	209	6.2%
F	193	5.7%
S	180	5.3%

Dash Punctuation

Value	Count	Frequency (%)
-	3381	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	10143	50.0%
Latin	10143	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
J	1444	14.2%
u	1436	14.2%
l	1070	10.5%
a	651	6.4%
e	635	6.3%
c	494	4.9%
r	465	4.6%
M	452	4.5%
A	409	4.0%
p	398	3.9%
Other values (12)	2689	26.5%

Common

Value	Count	Frequency (%)
1	3744	36.9%
-	3381	33.3%
6	919	9.1%
0	840	8.3%
2	423	4.2%
3	335	3.3%
9	285	2.8%
8	90	0.9%
5	70	0.7%
4	55	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20286	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	3744	18.5%
-	3381	16.7%
J	1444	7.1%
u	1436	7.1%
l	1070	5.3%
6	919	4.5%
0	840	4.1%
a	651	3.2%
e	635	3.1%
c	494	2.4%
Other values (23)	5672	28.0%

last_credit_pull_d
Text

Distinct	108
Distinct (%)	0.3%
Missing	3
Missing (%)	< 0.1%
Memory size	300.7 KiB

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	230850
Distinct characters	33
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Jun-16
2nd row	Mar-12
3rd row	Mar-14
4th row	Jun-16
5th row	Jun-16

Value	Count	Frequency (%)
jun-16	11342	29.5%
mar-16	1015	2.6%
apr-16	816	2.1%
feb-13	794	2.1%
may-16	695	1.8%
feb-16	664	1.7%
dec-15	602	1.6%
jan-16	591	1.5%
mar-13	564	1.5%
mar-14	522	1.4%
Other values (98)	20870	54.2%

Most occurring characters

Value	Count	Frequency (%)
1	40355	17.5%
-	38475	16.7%
J	16922	7.3%
u	16904	7.3%
6	15123	6.6%
n	14974	6.5%
a	7638	3.3%
e	7274	3.2%
r	5757	2.5%
4	5726	2.5%
Other values (23)	61702	26.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	76950	33.3%
Lowercase Letter	76950	33.3%
Dash Punctuation	38475	16.7%
Uppercase Letter	38475	16.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
u	16904	22.0%
n	14974	19.5%
a	7638	9.9%
e	7274	9.5%
r	5757	7.5%
p	4644	6.0%
c	4293	5.6%
b	2898	3.8%
y	2520	3.3%
o	2098	2.7%
Other values (4)	7950	10.3%

Decimal Number

Value	Count	Frequency (%)
1	40355	52.4%
6	15123	19.7%
4	5726	7.4%
5	5084	6.6%
3	4875	6.3%
2	3882	5.0%
0	1456	1.9%
9	351	0.5%
8	56	0.1%
7	42	0.1%

Uppercase Letter

Value	Count	Frequency (%)
J	16922	44.0%
M	5675	14.7%
A	4547	11.8%
F	2898	7.5%
D	2334	6.1%
N	2098	5.5%
S	2042	5.3%
O	1959	5.1%

Dash Punctuation

Value	Count	Frequency (%)
-	38475	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	115425	50.0%
Latin	115425	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
J	16922	14.7%
u	16904	14.6%
n	14974	13.0%
a	7638	6.6%
e	7274	6.3%
r	5757	5.0%
M	5675	4.9%
p	4644	4.0%
A	4547	3.9%
c	4293	3.7%
Other values (12)	26797	23.2%

Common

Value	Count	Frequency (%)
1	40355	35.0%
-	38475	33.3%
6	15123	13.1%
4	5726	5.0%
5	5084	4.4%
3	4875	4.2%
2	3882	3.4%
0	1456	1.3%
9	351	0.3%
8	56	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	230850	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	40355	17.5%
-	38475	16.7%
J	16922	7.3%
u	16904	7.3%
6	15123	6.6%
n	14974	6.5%
a	7638	3.3%
e	7274	3.2%
r	5757	2.5%
4	5726	2.5%
Other values (23)	61702	26.7%

repay_fail
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	300.7 KiB

0	32650
1	5828

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	38478
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	32650	84.9%
1	5828	15.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	32650	84.9%
1	5828	15.1%

Most occurring characters

Value	Count	Frequency (%)
0	32650	84.9%
1	5828	15.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	38478	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	32650	84.9%
1	5828	15.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	38478	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	32650	84.9%
1	5828	15.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	38478	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	32650	84.9%
1	5828	15.1%

Auto

Heatmap
Table

	loan_amnt	funded_amnt	funded_amnt_inv	int_rate	installment	annual_inc	dti	delinq_2yrs	inq_last_6mths	mths_since_last_delinq	open_acc	pub_rec	revol_bal	total_acc	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	last_pymnt_amnt	term	emp_length	home_ownership	verification_status	loan_status	purpose	addr_state	repay_fail
loan_amnt	1.000	0.991	0.917	0.233	0.959	0.435	0.071	-0.035	-0.027	0.029	0.211	-0.050	0.400	0.278	0.881	0.821	0.831	0.775	0.453	0.356	0.055	0.090	0.308	0.062	0.117	0.021	0.049
funded_amnt	0.991	1.000	0.928	0.240	0.973	0.431	0.071	-0.036	-0.027	0.031	0.208	-0.051	0.395	0.273	0.890	0.831	0.840	0.783	0.457	0.337	0.055	0.088	0.302	0.060	0.116	0.018	0.046
funded_amnt_inv	0.917	0.928	1.000	0.219	0.889	0.401	0.077	-0.048	-0.064	0.140	0.189	-0.055	0.361	0.263	0.846	0.907	0.799	0.742	0.445	0.368	0.061	0.086	0.316	0.086	0.107	0.033	0.046
int_rate	0.233	0.240	0.219	1.000	0.234	0.059	0.126	0.163	0.205	-0.041	-0.013	0.102	0.133	-0.058	0.206	0.188	0.098	0.489	0.065	0.458	0.024	0.052	0.158	0.107	0.059	0.014	0.199
installment	0.959	0.973	0.889	0.234	1.000	0.429	0.065	-0.022	-0.015	0.014	0.202	-0.045	0.397	0.253	0.865	0.796	0.828	0.734	0.442	0.144	0.045	0.073	0.266	0.037	0.114	0.018	0.031
annual_inc	0.435	0.431	0.401	0.059	0.429	1.000	-0.091	0.035	0.024	0.019	0.314	-0.014	0.406	0.437	0.408	0.382	0.400	0.311	0.246	0.000	0.003	0.000	0.006	0.000	0.000	0.015	0.000
dti	0.071	0.071	0.077	0.126	0.065	-0.091	1.000	-0.039	0.019	0.064	0.315	0.001	0.337	0.250	0.060	0.065	0.038	0.120	0.011	0.077	0.018	0.021	0.072	0.030	0.082	0.034	0.044
delinq_2yrs	-0.035	-0.036	-0.048	0.163	-0.022	0.035	-0.039	1.000	0.020	-0.672	0.009	0.006	-0.082	0.073	-0.028	-0.041	-0.042	0.021	-0.022	0.000	0.000	0.009	0.000	0.012	0.014	0.014	0.019
inq_last_6mths	-0.027	-0.027	-0.064	0.205	-0.015	0.024	0.019	0.020	1.000	-0.030	0.094	0.053	-0.031	0.094	-0.058	-0.086	-0.075	0.005	-0.018	0.039	0.011	0.021	0.050	0.250	0.031	0.088	0.087
mths_since_last_delinq	0.029	0.031	0.140	-0.041	0.014	0.019	0.064	-0.672	-0.030	1.000	0.043	0.059	0.080	0.042	0.037	0.132	0.039	0.025	0.042	0.070	0.040	0.025	0.086	0.058	0.011	0.051	0.038
open_acc	0.211	0.208	0.189	-0.013	0.202	0.314	0.315	0.009	0.094	0.043	1.000	0.008	0.404	0.696	0.188	0.171	0.183	0.153	0.100	0.051	0.036	0.111	0.072	0.028	0.050	0.022	0.020
pub_rec	-0.050	-0.051	-0.055	0.102	-0.045	-0.014	0.001	0.006	0.053	0.059	0.008	1.000	-0.053	-0.004	-0.058	-0.060	-0.069	-0.002	-0.038	0.000	0.028	0.011	0.006	0.033	0.015	0.037	0.058
revol_bal	0.400	0.395	0.361	0.133	0.397	0.406	0.337	-0.082	-0.031	0.080	0.404	-0.053	1.000	0.392	0.357	0.327	0.333	0.341	0.163	0.019	0.014	0.035	0.021	0.080	0.021	0.028	0.016
total_acc	0.278	0.273	0.263	-0.058	0.253	0.437	0.250	0.073	0.094	0.042	0.696	-0.004	0.392	1.000	0.243	0.235	0.243	0.162	0.178	0.098	0.076	0.171	0.100	0.030	0.053	0.035	0.033
total_pymnt	0.881	0.890	0.846	0.206	0.865	0.408	0.060	-0.028	-0.058	0.037	0.188	-0.058	0.357	0.243	1.000	0.943	0.977	0.823	0.499	0.332	0.048	0.078	0.279	0.127	0.100	0.018	0.301
total_pymnt_inv	0.821	0.831	0.907	0.188	0.796	0.382	0.065	-0.041	-0.086	0.132	0.171	-0.060	0.327	0.235	0.943	1.000	0.921	0.777	0.484	0.352	0.054	0.078	0.286	0.133	0.095	0.023	0.293
total_rec_prncp	0.831	0.840	0.799	0.098	0.828	0.400	0.038	-0.042	-0.075	0.039	0.183	-0.069	0.333	0.243	0.977	0.921	1.000	0.723	0.539	0.251	0.047	0.081	0.267	0.171	0.101	0.021	0.454
total_rec_int	0.775	0.783	0.742	0.489	0.734	0.311	0.120	0.021	0.005	0.025	0.153	-0.002	0.341	0.162	0.823	0.777	0.723	1.000	0.249	0.534	0.042	0.059	0.252	0.120	0.069	0.007	0.009
last_pymnt_amnt	0.453	0.457	0.445	0.065	0.442	0.246	0.011	-0.022	-0.018	0.042	0.100	-0.038	0.163	0.178	0.499	0.484	0.539	0.249	1.000	0.235	0.028	0.052	0.148	0.087	0.045	0.000	0.227
term	0.356	0.337	0.368	0.458	0.144	0.000	0.077	0.000	0.039	0.070	0.051	0.000	0.019	0.098	0.332	0.352	0.251	0.534	0.235	1.000	0.119	0.109	0.267	0.319	0.114	0.051	0.134
emp_length	0.055	0.055	0.061	0.024	0.045	0.003	0.018	0.000	0.011	0.040	0.036	0.028	0.014	0.076	0.048	0.054	0.047	0.042	0.028	0.119	1.000	0.131	0.087	0.030	0.037	0.021	0.014
home_ownership	0.090	0.088	0.086	0.052	0.073	0.000	0.021	0.009	0.021	0.025	0.111	0.011	0.035	0.171	0.078	0.078	0.081	0.059	0.052	0.109	0.131	1.000	0.074	0.035	0.123	0.132	0.023
verification_status	0.308	0.302	0.316	0.158	0.266	0.006	0.072	0.000	0.050	0.086	0.072	0.006	0.021	0.100	0.279	0.286	0.267	0.252	0.148	0.267	0.087	0.074	1.000	0.108	0.096	0.043	0.031
loan_status	0.062	0.060	0.086	0.107	0.037	0.000	0.030	0.012	0.250	0.058	0.028	0.033	0.080	0.030	0.127	0.133	0.171	0.120	0.087	0.319	0.030	0.035	0.108	1.000	0.046	0.053	1.000
purpose	0.117	0.116	0.107	0.059	0.114	0.000	0.082	0.014	0.031	0.011	0.050	0.015	0.021	0.053	0.100	0.095	0.101	0.069	0.045	0.114	0.037	0.123	0.096	0.046	1.000	0.033	0.098
addr_state	0.021	0.018	0.033	0.014	0.018	0.015	0.034	0.014	0.088	0.051	0.022	0.037	0.028	0.035	0.018	0.023	0.021	0.007	0.000	0.051	0.021	0.132	0.043	0.053	0.033	1.000	0.056
repay_fail	0.049	0.046	0.046	0.199	0.031	0.000	0.044	0.019	0.087	0.038	0.020	0.058	0.016	0.033	0.301	0.293	0.454	0.009	0.227	0.134	0.014	0.023	0.031	1.000	0.098	0.056	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	loan_amnt	funded_amnt	funded_amnt_inv	term	int_rate	installment	emp_length	home_ownership	annual_inc	verification_status	issue_d	loan_status	purpose	zip_code	addr_state	dti	delinq_2yrs	earliest_cr_line	inq_last_6mths	mths_since_last_delinq	open_acc	pub_rec	revol_bal	revol_util	total_acc	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	last_pymnt_d	last_pymnt_amnt	next_pymnt_d	last_credit_pull_d	repay_fail
0	2500.0	2500.0	2500.00000	36 months	13.98	85.42	4 years	RENT	20004.0	Not Verified	Jul-10	Does not meet the credit policy. Status:Fully Paid	other	487xx	MI	19.86	0.0	Aug-05	5.0	NaN	7.0	0.0	981.0	21.30%	10.0	3075.291779	3075.29	2500.00	575.29	Jul-13	90.85	Aug-13	Jun-16	0
1	5000.0	5000.0	5000.00000	36 months	15.95	175.67	4 years	RENT	59000.0	Not Verified	Jun-10	Charged Off	debt_consolidation	115xx	NY	19.57	0.0	Apr-94	1.0	59.0	7.0	0.0	18773.0	99.90%	15.0	2948.760000	2948.76	1909.02	873.81	Nov-11	175.67	NaN	Mar-12	1
2	7000.0	7000.0	7000.00000	36 months	9.91	225.58	10+ years	MORTGAGE	53796.0	Not Verified	Sep-11	Fully Paid	other	751xx	TX	10.80	3.0	Mar-98	3.0	3.0	7.0	0.0	3269.0	47.20%	20.0	8082.391880	8082.39	7000.00	1082.39	Mar-14	1550.27	NaN	Mar-14	0
3	2000.0	2000.0	2000.00000	36 months	5.42	60.32	10+ years	RENT	30000.0	Not Verified	Sep-11	Fully Paid	debt_consolidation	112xx	NY	3.60	0.0	Jan-75	0.0	72.0	7.0	0.0	0.0	0%	15.0	2161.663244	2161.66	2000.00	161.66	Feb-14	53.12	NaN	Jun-16	0
4	3600.0	3600.0	3600.00000	36 months	10.25	116.59	10+ years	MORTGAGE	675048.0	Not Verified	Apr-10	Does not meet the credit policy. Status:Fully Paid	other	352xx	AL	1.55	0.0	Apr-98	4.0	25.0	8.0	0.0	0.0	0%	25.0	4206.031191	4206.03	3600.00	606.03	May-13	146.75	Jun-13	Jun-16	0
5	8000.0	8000.0	8000.00000	36 months	6.03	243.49	NaN	MORTGAGE	77736.0	Verified	Oct-11	Fully Paid	other	853xx	AZ	6.07	0.0	Jul-96	0.0	NaN	12.0	0.0	4182.0	13.60%	49.0	8724.971815	8724.97	8000.00	724.97	Apr-14	1423.66	NaN	Apr-14	0
6	6000.0	6000.0	6000.00000	36 months	7.49	186.61	3 years	RENT	35000.0	Not Verified	May-11	Fully Paid	debt_consolidation	658xx	MO	13.13	0.0	Oct-03	0.0	NaN	5.0	0.0	5864.0	47.70%	9.0	6717.950109	6717.95	6000.00	717.95	May-14	211.41	NaN	May-14	0
7	25600.0	25600.0	25472.82947	60 months	14.27	599.26	4 years	RENT	86000.0	Verified	Nov-11	Fully Paid	debt_consolidation	105xx	NY	26.51	0.0	Oct-83	1.0	NaN	16.0	0.0	33021.0	70.80%	32.0	32840.056740	32659.13	25600.00	7240.06	Apr-14	16083.78	NaN	Jun-16	0
8	19750.0	19750.0	19750.00000	60 months	23.22	559.27	10+ years	MORTGAGE	72500.0	Verified	Jun-11	Fully Paid	debt_consolidation	630xx	MO	19.96	0.0	Mar-92	0.0	61.0	15.0	0.0	21544.0	98.70%	44.0	27544.891160	27544.89	19750.00	7794.89	Jun-13	15264.34	NaN	Feb-16	0
9	6250.0	6250.0	6250.00000	36 months	17.27	223.68	4 years	MORTGAGE	28000.0	Verified	Nov-11	Charged Off	other	450xx	OH	13.76	0.0	Oct-99	0.0	41.0	2.0	1.0	0.0	8.46%	15.0	6688.640000	6688.64	4764.18	1713.09	Apr-14	223.68	NaN	Sep-14	1

	loan_amnt	funded_amnt	funded_amnt_inv	term	int_rate	installment	emp_length	home_ownership	annual_inc	verification_status	issue_d	loan_status	purpose	zip_code	addr_state	dti	delinq_2yrs	earliest_cr_line	inq_last_6mths	mths_since_last_delinq	open_acc	pub_rec	revol_bal	revol_util	total_acc	total_pymnt	total_pymnt_inv	total_rec_prncp	total_rec_int	last_pymnt_d	last_pymnt_amnt	next_pymnt_d	last_credit_pull_d	repay_fail
38468	4000.0	4000.0	4000.00000	36 months	14.27	137.24	6 years	MORTGAGE	50000.0	Not Verified	Nov-11	Fully Paid	credit_card	330xx	FL	19.20	1.0	Aug-96	0.0	23.0	23.0	0.0	17561.0	63.60%	43.0	4940.450000	4940.45	4000.00	940.45	Nov-14	149.24	NaN	Nov-14	0
38469	1500.0	1500.0	1500.00000	36 months	16.29	52.96	1 year	RENT	27000.0	Not Verified	Oct-11	Charged Off	wedding	301xx	GA	18.53	0.0	Sep-07	2.0	NaN	9.0	0.0	743.0	26.50%	12.0	86.050000	86.05	0.00	0.00	NaN	0.00	NaN	Apr-12	1
38470	7200.0	7200.0	7200.00000	36 months	15.05	249.78	4 years	OTHER	75000.0	Source Verified	Feb-09	Fully Paid	debt_consolidation	021xx	MA	8.00	1.0	Dec-96	0.0	18.0	4.0	0.0	17321.0	87.60%	11.0	8991.939341	8991.94	7200.00	1791.94	Mar-12	251.68	NaN	Mar-12	0
38471	6000.0	6000.0	0.00000	36 months	12.92	201.94	1 year	RENT	32000.0	Not Verified	Jun-08	Fully Paid	car	210xx	MD	4.76	0.0	Sep-04	0.0	NaN	7.0	0.0	4378.0	71.20%	7.0	7023.835297	0.00	6000.00	1023.84	Mar-10	2985.40	NaN	Apr-15	0
38472	6925.0	6925.0	6900.00000	36 months	9.62	222.22	< 1 year	RENT	78000.0	Verified	Dec-10	Charged Off	debt_consolidation	031xx	NH	15.40	0.0	Nov-03	2.0	43.0	17.0	0.0	7297.0	34.30%	22.0	6108.790000	6086.77	4994.45	995.23	Mar-13	222.22	NaN	Aug-13	1
38473	3000.0	3000.0	3000.00000	36 months	11.99	99.63	3 years	RENT	74250.0	Verified	Aug-11	Fully Paid	credit_card	805xx	CO	22.17	0.0	Jan-00	2.0	NaN	12.0	0.0	16550.0	73.50%	22.0	3586.619764	3586.62	3000.00	586.62	Aug-14	100.30	NaN	Jun-16	0
38474	10400.0	10400.0	10400.00000	36 months	13.49	352.88	9 years	RENT	62000.0	Source Verified	Aug-11	Fully Paid	credit_card	442xx	OH	11.57	0.0	Apr-99	1.0	NaN	21.0	0.0	16898.0	39.70%	33.0	12703.534030	12703.53	10400.00	2303.53	Sep-14	393.08	NaN	Jun-16	0
38475	16000.0	10550.0	10531.35818	60 months	14.96	250.77	10+ years	MORTGAGE	95088.0	Source Verified	May-10	Fully Paid	debt_consolidation	073xx	NJ	10.63	0.0	Dec-95	1.0	NaN	9.0	1.0	10386.0	62.20%	25.0	14202.267530	14163.31	10550.00	3652.27	Jun-13	5439.96	NaN	Feb-16	0
38476	10000.0	10000.0	10000.00000	36 months	16.89	355.99	1 year	RENT	48720.0	Not Verified	Jul-11	Fully Paid	debt_consolidation	061xx	CT	18.97	0.0	Jul-07	2.0	NaN	8.0	0.0	7301.0	53.30%	12.0	12815.178320	12815.18	10000.00	2815.18	Aug-14	380.63	NaN	Sep-15	0
38477	3200.0	3200.0	3200.00000	36 months	13.49	108.58	7 years	RENT	38400.0	Source Verified	Nov-11	Fully Paid	debt_consolidation	484xx	MI	12.56	0.0	Oct-95	2.0	38.0	8.0	1.0	2503.0	62.60%	18.0	3908.767275	3908.77	3200.00	708.77	Dec-14	111.88	NaN	Nov-14	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Math Symbol

Space Separator

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)